Tabela ContractData

Definicja tabeli ContractData

Name

ContractData

Code

ContractData

Comment

 


Lista kolumn tabeli ContractData

Name

Code

ContractDataID

ContractDataID

ContractID

ContractID

DateRestrictionID

DateRestrictionID

AccountingSchemaID

AccountingSchemaID

RatioSchemaID

RatioSchemaID

ContractServiceKindID

ContractServiceKindID

UnitsCount

UnitsCount

Price

Price

StartDT

StartDT

StopDT

StopDT

Active

Active

PreviousPrice

PreviousPrice

PreviousUnitsCount

PreviousUnitsCount

AccountingPeriodID

AccountingPeriodID

ReportingPeriodID

ReportingPeriodID

PriceRatio

PriceRatio

PackageID

PackageID

GrouperVersionNo

GrouperVersionNo

PositionGroupNo

PositionGroupNo

Month

Month

Year

Year

RealPrice

RealPrice

PerfUnitsCount

PerfUnitsCount

KindOfPeriod

KindOfPeriod

NumberOfPeriod

NumberOfPeriod

Quantity

Quantity

Refund

Refund

RegionCode

RegionCode

AccountingPeriodMonthFrom

AccountingPeriodMonthFrom

AccountingPeriodMonthTo

AccountingPeriodMonthTo

VatRate

VatRate

VatMultiplier

VatMultiplier

AnexID

AnexID

LumpSumContractServId

LumpSumContractServId


Kolumna ContractDataID tabeli ContractData

Definicja kolumny ContractDataID tabeli ContractData

Name

ContractDataID

Code

ContractDataID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ContractID tabeli ContractData

Definicja kolumny ContractID tabeli ContractData

Name

ContractID

Code

ContractID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DateRestrictionID tabeli ContractData

Definicja kolumny DateRestrictionID tabeli ContractData

Name

DateRestrictionID

Code

DateRestrictionID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AccountingSchemaID tabeli ContractData

Definicja kolumny AccountingSchemaID tabeli ContractData

Name

AccountingSchemaID

Code

AccountingSchemaID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna RatioSchemaID tabeli ContractData

Definicja kolumny RatioSchemaID tabeli ContractData

Name

RatioSchemaID

Code

RatioSchemaID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractServiceKindID tabeli ContractData

Definicja kolumny ContractServiceKindID tabeli ContractData

Name

ContractServiceKindID

Code

ContractServiceKindID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UnitsCount tabeli ContractData

Definicja kolumny UnitsCount tabeli ContractData

Name

UnitsCount

Code

UnitsCount

Data Type

NUMBER(19,4)

Mandatory

No

Comment

 


Kolumna Price tabeli ContractData

Definicja kolumny Price tabeli ContractData

Name

Price

Code

Price

Data Type

NUMBER(22,6)

Mandatory

No

Comment

 


Kolumna StartDT tabeli ContractData

Definicja kolumny StartDT tabeli ContractData

Name

StartDT

Code

StartDT

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna StopDT tabeli ContractData

Definicja kolumny StopDT tabeli ContractData

Name

StopDT

Code

StopDT

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna Active tabeli ContractData

Definicja kolumny Active tabeli ContractData

Name

Active

Code

Active

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna PreviousPrice tabeli ContractData

Definicja kolumny PreviousPrice tabeli ContractData

Name

PreviousPrice

Code

PreviousPrice

Data Type

NUMBER(22,6)

Mandatory

No

Comment

 


Kolumna PreviousUnitsCount tabeli ContractData

Definicja kolumny PreviousUnitsCount tabeli ContractData

Name

PreviousUnitsCount

Code

PreviousUnitsCount

Data Type

NUMBER(19,4)

Mandatory

No

Comment

 


Kolumna AccountingPeriodID tabeli ContractData

Definicja kolumny AccountingPeriodID tabeli ContractData

Name

AccountingPeriodID

Code

AccountingPeriodID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ReportingPeriodID tabeli ContractData

Definicja kolumny ReportingPeriodID tabeli ContractData

Name

ReportingPeriodID

Code

ReportingPeriodID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PriceRatio tabeli ContractData

Definicja kolumny PriceRatio tabeli ContractData

Name

PriceRatio

Code

PriceRatio

Data Type

NUMBER(6,2)

Mandatory

No

Comment

 


Kolumna PackageID tabeli ContractData

Definicja kolumny PackageID tabeli ContractData

Name

PackageID

Code

PackageID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna GrouperVersionNo tabeli ContractData

Definicja kolumny GrouperVersionNo tabeli ContractData

Name

GrouperVersionNo

Code

GrouperVersionNo

Data Type

VARCHAR2(10)

Mandatory

No

Comment

 


Kolumna PositionGroupNo tabeli ContractData

Definicja kolumny PositionGroupNo tabeli ContractData

Name

PositionGroupNo

Code

PositionGroupNo

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Month tabeli ContractData

Definicja kolumny Month tabeli ContractData

Name

Month

Code

Month

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Year tabeli ContractData

Definicja kolumny Year tabeli ContractData

Name

Year

Code

Year

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna RealPrice tabeli ContractData

Definicja kolumny RealPrice tabeli ContractData

Name

RealPrice

Code

RealPrice

Data Type

NUMBER(19,4)

Mandatory

No

Comment

 


Kolumna PerfUnitsCount tabeli ContractData

Definicja kolumny PerfUnitsCount tabeli ContractData

Name

PerfUnitsCount

Code

PerfUnitsCount

Data Type

NUMBER(14,4)

Mandatory

No

Comment

 


Kolumna KindOfPeriod tabeli ContractData

Definicja kolumny KindOfPeriod tabeli ContractData

Name

KindOfPeriod

Code

KindOfPeriod

Data Type

VARCHAR2(2)

Mandatory

No

Comment

 


Kolumna NumberOfPeriod tabeli ContractData

Definicja kolumny NumberOfPeriod tabeli ContractData

Name

NumberOfPeriod

Code

NumberOfPeriod

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Quantity tabeli ContractData

Definicja kolumny Quantity tabeli ContractData

Name

Quantity

Code

Quantity

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Refund tabeli ContractData

Definicja kolumny Refund tabeli ContractData

Name

Refund

Code

Refund

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna RegionCode tabeli ContractData

Definicja kolumny RegionCode tabeli ContractData

Name

RegionCode

Code

RegionCode

Data Type

VARCHAR2(15)

Mandatory

No

Comment

 


Kolumna AccountingPeriodMonthFrom tabeli ContractData

Definicja kolumny AccountingPeriodMonthFrom tabeli ContractData

Name

AccountingPeriodMonthFrom

Code

AccountingPeriodMonthFrom

Data Type

NUMBER(5)

Mandatory

No

Comment

Miesiac poczatku okresu rozliczeniowego


Kolumna AccountingPeriodMonthTo tabeli ContractData

Definicja kolumny AccountingPeriodMonthTo tabeli ContractData

Name

AccountingPeriodMonthTo

Code

AccountingPeriodMonthTo

Data Type

NUMBER(5)

Mandatory

No

Comment

Miesiac konca okresu rozliczeniowego


Kolumna VatRate tabeli ContractData

Definicja kolumny VatRate tabeli ContractData

Name

VatRate

Code

VatRate

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Kolumna VatMultiplier tabeli ContractData

Definicja kolumny VatMultiplier tabeli ContractData

Name

VatMultiplier

Code

VatMultiplier

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna AnexID tabeli ContractData

Definicja kolumny AnexID tabeli ContractData

Name

AnexID

Code

AnexID

Data Type

NUMBER(10)

Mandatory

No

Comment

Id ostatniego kontraktu, który spowodowal zmiane danych na ContractData


Kolumna LumpSumContractServId tabeli ContractData

Definicja kolumny LumpSumContractServId tabeli ContractData

Name

LumpSumContractServId

Code

LumpSumContractServId

Data Type

NUMBER(10)

Mandatory

No

Comment

link do "ryczaltowego" produktu kontraktowego


Lista kluczy tabeli ContractData

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ContractData

Definicja klucza Identifier_1 tabeli ContractData

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment